HW#1 --- last modified January 01 1970 00:00:00..

Solution set.

Due date: Sep 11

Files to be submitted:
  Problems.doc
  RequirementsER.doc
  Pet.mdb

Purpose: The purpose of this assignment is to refresh our memories about database design from CS157a as wells as do some simple problems related to OO databases.

Specification:

Do problems 11.14 and 11.15 from E&N. Submit these in the file Problems.doc. Then pretend that you have been put in charge of designing the database for an on-line pet store. (Please do not turn in a sock-puppet with this assignment.) In the file RequirementsER.doc come up with a list of requirements such a retailer might have. Then in the same file suggest an E-R diagram for this retailer. Do the E-R to relational model mapping (make sure to give foreign key constraints clearly!) and give the result in your file. Say which of the normal forms 1-5 and BCNF the resulting schema satisfies. Implement the resulting schema in Access (adding 3 rows to each table). Submit the database as Pet.mdb.

Point Breakdown